[dbo].[OrderProductCategoryLookup]

Property	Value
Row Count	15
Created	10:31:30 AM Tuesday, March 02, 2010
Last Modified	11:40:05 AM Monday, February 20, 2012

Property

Value

Row Count

Created

10:31:30 AM Tuesday, March 02, 2010

Last Modified

11:40:05 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_OrderProductCategoryLookup: OrderProductID\OrderCategoryID$	OrderProductID	int	4
$Cluster Primary Key PK_OrderProductCategoryLookup: OrderProductID\OrderCategoryID$	OrderCategoryID	int	4
	IsFeatured	bit	1
	SortOrder	int	4

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_OrderProductCategoryLookup: OrderProductID\OrderCategoryID$

OrderProductID

int

$Cluster Primary Key PK_OrderProductCategoryLookup: OrderProductID\OrderCategoryID$

OrderCategoryID

int

IsFeatured

bit

SortOrder

int

	Name	Columns	Unique
$Cluster Primary Key PK_OrderProductCategoryLookup: OrderProductID\OrderCategoryID$	PK_OrderProductCategoryLookup	OrderProductID, OrderCategoryID

Name

Columns

Unique

$Cluster Primary Key PK_OrderProductCategoryLookup: OrderProductID\OrderCategoryID$

PK_OrderProductCategoryLookup

OrderProductID, OrderCategoryID

Name	Update	Delete	Columns
FK_OrderProductCategoryLookup_OrderCategory	Cascade	Cascade	OrderCategoryID->[dbo].[OrderCategory].[OrderCategoryID]
FK_OrderProductCategoryLookup_OrderProduct	Cascade	Cascade	OrderProductID->[dbo].[OrderProduct].[OrderProductID]

Name

Update

Delete

Columns

FK_OrderProductCategoryLookup_OrderCategory

Cascade

OrderCategoryID->[dbo].[OrderCategory].[OrderCategoryID]

FK_OrderProductCategoryLookup_OrderProduct

Cascade

OrderProductID->[dbo].[OrderProduct].[OrderProductID]

SQL Script

CREATE TABLE [dbo].[OrderProductCategoryLookup]
(
[OrderProductID] [int] NOT NULL,
[OrderCategoryID] [int] NOT NULL,
[IsFeatured] [bit] NOT NULL,
[SortOrder] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[OrderProductCategoryLookup] ADD CONSTRAINT [PK_OrderProductCategoryLookup] PRIMARY KEY CLUSTERED ([OrderProductID], [OrderCategoryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[OrderProductCategoryLookup] ADD CONSTRAINT [FK_OrderProductCategoryLookup_OrderCategory] FOREIGN KEY ([OrderCategoryID]) REFERENCES [dbo].[OrderCategory] ([OrderCategoryID]) ON DELETE CASCADE ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[OrderProductCategoryLookup] ADD CONSTRAINT [FK_OrderProductCategoryLookup_OrderProduct] FOREIGN KEY ([OrderProductID]) REFERENCES [dbo].[OrderProduct] ([OrderProductID]) ON DELETE CASCADE ON UPDATE CASCADE
GO